
<?php
/**
 * RUBIK IT Solution & Development Co.ltd,
 *
 * PROJECT		: Auction
 * COPYRIGHT	: 2010
 * ------------------------------------------------------
 * 
 * DTO class of  #__vehicle table
 *
 * @author			generator <hoadn@rubik.com.vn>
 * @access			public
 * @package			dbo.VehicleDTO
 *
 * Created on	: September 13, 2010
 */

// Importer
RCoreImporter::cls( "dbo.AbstractDTO" );

/**
 * @name UserDTO
 * The data transfer object class for table: #__vehicle
 */
class ProductDTOView extends AbstractDTO {

	// Keys
	var $product_id		= "N*|||key";

	// Colums
	var $product_name	= "S";
	var $price			= "N";	
	var $content_vi	= "TX";
	var $content_en	= "TX";	
	var $image			= "S";
	var $sub_category_id= "N||pd";
	var $sub_category_name_vi= "S||sc";
	var $active					= "B|0";
	var $latest_product			= "B|0";
	
	/**	
	 * Constructor	
	 *	
	 * @param string $where	 the where string (without WHERE)
	 * @param string $orderBy the other by string (with order by)
	 * @param DataBase $db the database (if null the database of system will be specify)
	 */	
	function __construct($where='', $orderBy = '', $db = null) {	
		$sql = "FROM product AS pd LEFT JOIN sub_category AS sc ON pd.sub_category_id = sc.sub_category_id";
//		parent::__construct('#__vehicle', ' deleted=0 ', $orderBy, $db);
		parent::__construct($sql, $where, $orderBy, $db);
	}	
	
}
?>
